Skip to main content

Mixpanel

Adding Mixpanel as data source

Do the following to add Mixpanel as data source:

  1. From the left navigation panel, click Lakehouse and then click Data Sources.
  2. From the upper right corner of the page, click the + New Data Source button to start the process of adding a new database.
  3. In the New Data Source page, click the Mixpanel icon.
  4. Specify the following details to add Mixpanel. Once you have connected a data source, the system immediately fetches its schema. After this schema retrieval process is complete you can browse and interact with the tables and data.
FieldDescription
Connection NameEnter a unique name for the connection.
UsernameSpecify your Mixpanel Service Account Username.
SecretSpecify your Mixpanel Service Account Secret.
Project IDSpecify your Mixpanel Project ID. This can be found in your Project Settings.
Project TimezoneSpecify the timezone for your Mixpanel project (e.g., UTC). The project timezone can be found in the project settings in the Mixpanel console.
RegionSpecify the region for your Mixpanel project. Typical values are US or EU.
Start DateEnter the date in the MM-DD-YYYY format. DataGOL will replicate the data updated on and after this date. If this field is blank, DataGOL will replicate data for the last year by default. This will apply only to the Incremental streams.
  1. Click Submit.

Supported sync modes

  • Full Refresh - Overwrite
  • Full Refresh - Append
  • Incremental - Append
  • Incremental - Append + Deduped

Supported streams

  • Export (Incremental)
  • Engage (Incremental)
  • Funnels (Incremental)
  • Revenue (Incremental)
  • Annotations (Full table)
  • Cohorts (Incremental)
  • Cohort Members (Incremental)

Was this helpful?